insert overwrite table yl_ods.yl_lmdm_sys_user partition(dt)
select
id
,staff_no
,null as name
,en_name
,null as cn_name
,sex
,user_type
,network_id
,network_name
,dept_id
,dept_name
,post_id
,post_name
,null as mobile
,null as email
,is_initialization
,app_is_initialization
,null as phone
,remark
,null as password
,null as app_password
,null as mac_addr
,config_color
,config_language
,is_enable
,is_delete
,create_by
,update_by
,create_by_name
,update_by_name
,create_time
,update_time
,version
,sort
,dept_level_id
,network_code
,dept_level_name
,site_login_flag
,null as password_salt
,post_code
,null as pc_login_device
,update_password_time
,last_login_time
,incumbency_status
,alert_msg
,msg_audio
,position
,dt
from jms_ods.yl_lmdm_sys_user
where dt = '{{ execution_date | cst_ds }}' ;